package pl.register.android.database.tables;

/**
 * @author Mateusz Strzelecki
 * @since 2013-04-14
 */

public class YearDBTable {
    public static final String TABLE_NAME = "StudentsYear";

    public static final String ID = "students_year_id";
    public static final String TYPE = "type_year";
    public static final String SUB_NAME = "sub_name_year";
    public static final String FK_COURSE_ID = "student_year_fk_course_id";

    public interface Query {
        public static final String CREATE_TABLE =
                "CREATE TABLE IF NOT EXISTS " + TABLE_NAME +
                        "(" +
                        ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                        TYPE + " TEXT NOT NULL, " +
                        SUB_NAME + " TEXT NOT NULL, " +
                        FK_COURSE_ID + " INTEGER NOT NULL" +
                        ");";

        public static final String DROP_TABLE =
                "DROP TABLE IF EXISTS " + TABLE_NAME + ";";
    }


}